Tabela LEventICD

Definicja tabeli LEventICD

Name

LEventICD

Code

LEventICD

Comment

 


Lista kolumn tabeli LEventICD

Name

Code

UnitsCount

UnitsCount

PerfDT

PerfDT

LEventIcdID

LEventIcdID

EventID

EventID

ICDID

ICDID

ICDTypeID

ICDTypeID

OrgUnitID

OrgUnitID

RareDiseaseCode

RareDiseaseCode

PersonnelType

PersonnelType

PersonnelPeselOrNpwz

PersonnelPeselOrNpwz

DirectionalICD

DirectionalICD

PerfTime

PerfTime


Kolumna UnitsCount tabeli LEventICD

Definicja kolumny UnitsCount tabeli LEventICD

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli LEventICD

Definicja kolumny PerfDT tabeli LEventICD

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LEventIcdID tabeli LEventICD

Definicja kolumny LEventIcdID tabeli LEventICD

Name

LEventIcdID

Code

LEventIcdID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli LEventICD

Definicja kolumny EventID tabeli LEventICD

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

Yes

Comment

 


Kolumna ICDID tabeli LEventICD

Definicja kolumny ICDID tabeli LEventICD

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ICDTypeID tabeli LEventICD

Definicja kolumny ICDTypeID tabeli LEventICD

Name

ICDTypeID

Code

ICDTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitID tabeli LEventICD

Definicja kolumny OrgUnitID tabeli LEventICD

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RareDiseaseCode tabeli LEventICD

Definicja kolumny RareDiseaseCode tabeli LEventICD

Name

RareDiseaseCode

Code

RareDiseaseCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kolumna bedzie zawierala informacje o kodzie klasyfikacji wedlug klasyfikacji ORPHANET przekazywanym w przypadku chorób rzadkic


Kolumna PersonnelType tabeli LEventICD

Definicja kolumny PersonnelType tabeli LEventICD

Name

PersonnelType

Code

PersonnelType

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ personelu osoby kierujacej wykonaniem procedury


Kolumna PersonnelPeselOrNpwz tabeli LEventICD

Definicja kolumny PersonnelPeselOrNpwz tabeli LEventICD

Name

PersonnelPeselOrNpwz

Code

PersonnelPeselOrNpwz

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Identyfikator osoby kierujacej wykonaniem procedury


Kolumna DirectionalICD tabeli LEventICD

Definicja kolumny DirectionalICD tabeli LEventICD

Name

DirectionalICD

Code

DirectionalICD

Data Type

VARCHAR2(8)

Mandatory

No

Comment

kod procedury kierunkowej


Kolumna PerfTime tabeli LEventICD

Definicja kolumny PerfTime tabeli LEventICD

Name

PerfTime

Code

PerfTime

Data Type

DATE

Mandatory

No

Comment

czas wykonania procedury


Lista kluczy tabeli LEventICD

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LEventICD

Definicja klucza Identifier_1 tabeli LEventICD

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment